SQL Server
sqlserver 表空间查询 标签描述

SELECT t.NAMEASTableName, s.NameASSchemaName, p.rowsASRowCounts, SUM(a.total_pages)8ASTotalSpaceKB, CAST(ROUND(((SUM(a.total_pages)8)/1024.00),2)ASNUMERIC(36,2))ASTotalSpaceMB, SUM(a.used_pages)8ASUsedSpaceKB, CAST(ROUND(((SUM(a.used_pages)8)/1024.00),2)ASNUMERIC(36,2))ASUsedSpaceMB, (SUM(a.total_p...